import pandas as pd


df1 = pd.read_excel('../data/创业板指研究.xlsx')
df2 = pd.read_excel('../output/投资示范.xlsx')
hc_df1 = pd.merge(df1, df2, on=['year', 'month' , 'day'], how='outer')

hc_df1.to_excel('../output/合成表.xlsx' , index = False)
